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