UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Z3jlCL8gK1qsuu8t8smRUyADwBdUTeA2ijzFMhJ4G8='
WHERE
key_id = '7d607c8099045694f4da88085fb84ad356eb1992d7a3e4c67deabb96bf7ed3ad'
AND (
token = '1Z3jlCL8gK1qsuu8t8smRUyADwBdUTeA2ijzFMhJ4G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)