UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NV/AuHpYEapF0wUYb1gMmrQKdyqEVtkFZCrlpDDv534='
WHERE
key_id = '0cf8c7e0cfc3d8d00dbaf6379b6c287d6623f366e874d66b7c13eb7829ee6303'
AND (
token = 'NV/AuHpYEapF0wUYb1gMmrQKdyqEVtkFZCrlpDDv534='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)