UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iw55jdidvx+ZqJlLyV7lZiZL2eDmcjoJH+8z4dwOWf4='
WHERE
key_id = 'b4f36085b528cbd38d6c3e4e2dd7847174e7135defb84e7caed8bc8312a360a4'
AND (
token = 'iw55jdidvx+ZqJlLyV7lZiZL2eDmcjoJH+8z4dwOWf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)