UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pL9cgSxc23wyjYM74Ux83czreuvBU5xAFw23Owsjxvs='
WHERE
key_id = 'ecb5ebc7d7ea756417f06eb63bb68c4b560641c393581c327a6a19386b1f547a'
AND (
token = 'pL9cgSxc23wyjYM74Ux83czreuvBU5xAFw23Owsjxvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)