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