UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lD6eG3TkUvTUWTLkrOaEYGABud05ubNX6+WcabuaHJw='
WHERE
key_id = '27771587a663796ed64a6ac2d993f1b32f204562dbe0c29c20351e20e3859421'
AND (
token = 'lD6eG3TkUvTUWTLkrOaEYGABud05ubNX6+WcabuaHJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)