UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQ8IqaIil+jtdzUlIvSRIvEYIDxQtkfXBzUO48huz1I='
WHERE
key_id = '8e78f652afeeb5d765354ef77e742914e25ddcfebe45f601b2fd6231a707a154'
AND (
token = 'zQ8IqaIil+jtdzUlIvSRIvEYIDxQtkfXBzUO48huz1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)