UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/yXyMbVLPFcD1k2JJ3118H3VqddSu9VwpLWRgvy/MLE='
WHERE
key_id = '2b7d046018593d7f28fe3b152270a9026ab6c3422ac1aa45de425194b9d0de4c'
AND (
token = '/yXyMbVLPFcD1k2JJ3118H3VqddSu9VwpLWRgvy/MLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)