UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VFa0XqxjdVzg8NpEN72RsSheImQqVDNPDcmB38h60iw='
WHERE
key_id = '9aff7885782c597e7bed6b2382c203c4d66318143ab3c1e1ca054feb003550b5'
AND (
token = 'VFa0XqxjdVzg8NpEN72RsSheImQqVDNPDcmB38h60iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)