UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9qsyQ11q2STpY01FLGBN+ZBM/NTYJnH780+vH9oIcM='
WHERE
key_id = '7e8696e38c3cd7488d68eb24671027d124ec8fa12260e760d02f256c24c17556'
AND (
token = 'W9qsyQ11q2STpY01FLGBN+ZBM/NTYJnH780+vH9oIcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)