UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iR+VgXLG7VcTr3HeEjcZiN76uzSHq37oYRcT2JgIvw='
WHERE
key_id = '8f6c60564e94f7b022e98b8e94bd6643d5beac486fc3c1d9b17b88c462842003'
AND (
token = '6iR+VgXLG7VcTr3HeEjcZiN76uzSHq37oYRcT2JgIvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)