UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mJz9Ob8NLS7VUOR0VLO4P+JDR1sUdL2PwWcNggM+hnw='
WHERE
key_id = 'd6f9146a6c50027e1349e63ef17ff05c4d44e6bb6ad6746ca8f766190203d391'
AND (
token = 'mJz9Ob8NLS7VUOR0VLO4P+JDR1sUdL2PwWcNggM+hnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)