UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nkff9epb5TmmguyHzgNMBpPOvm0QIwbJznSbKr5IgNs='
WHERE
key_id = 'c9b674e9068251c478591a37c2bcfdad9d4fd85a9932d65ba5ad97372a433a06'
AND (
token = 'nkff9epb5TmmguyHzgNMBpPOvm0QIwbJznSbKr5IgNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)