UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5dt22MkxSllM3yvFe1jUoNSzjNLqFzxmONJinCn0BLA='
WHERE
key_id = '5a6eccb53561a63b5ae66a08cd1d7b8ab07324301c3c2a4b2456b6261f3e51bb'
AND (
token = '5dt22MkxSllM3yvFe1jUoNSzjNLqFzxmONJinCn0BLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)