UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7n28DCb/DD6bEnaru1rXuJsMnOoAWAYcElX+EBb0FOs='
WHERE
key_id = 'aab6489d09030fe663f852fdee71dfe59b6cca2d43255f5f61f6b5f82c4ec1d1'
AND (
token = '7n28DCb/DD6bEnaru1rXuJsMnOoAWAYcElX+EBb0FOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)