UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yIp6lTxeQRKO+qUW8kbccDbqLQF93Hy37o0KFzTCeNU='
WHERE
key_id = '28168227c38eb0f41a2685e3ce44a9feafc88e1c8bdab79a1bfa346d9d48ec2d'
AND (
token = 'yIp6lTxeQRKO+qUW8kbccDbqLQF93Hy37o0KFzTCeNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)