UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cphhNj5JaF0u6djmQKstKHeMMsVqHnT2AIx0irjtKO8='
WHERE
key_id = '1c29717246d68b006beab1d2cfcc8e0f4bfa7709ac2b0995d61bc842f8b808af'
AND (
token = 'cphhNj5JaF0u6djmQKstKHeMMsVqHnT2AIx0irjtKO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)