UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iUKaZ1U3294YhzowSDCv7UvzKhPD03SGBPWlVnLq1Cw='
WHERE
key_id = '3986798efcebb41b86b2ebbb1fcaaed68e8c0bd3e356856e591cb92900ea92d0'
AND (
token = 'iUKaZ1U3294YhzowSDCv7UvzKhPD03SGBPWlVnLq1Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)