UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pC8l7FbqBae978WKpJKKCR0wZdJGuRuGNrVMd0eQO1w='
WHERE
key_id = '42eb3a4598becd548d09e248f41f90d930e4440a4874e807c5c633f678a00b2b'
AND (
token = 'pC8l7FbqBae978WKpJKKCR0wZdJGuRuGNrVMd0eQO1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)