UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDIJcMKGc/TRku3kxYJpZt+5i5oRgcml30PhBIdfg4s='
WHERE
key_id = 'b5782bed86308462c2527a6a4c708c75b5eda63cb9e9b92a08931311772d773f'
AND (
token = 'zDIJcMKGc/TRku3kxYJpZt+5i5oRgcml30PhBIdfg4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)