UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k94eg5NJmEWIsmvI3Fh1uIowTG2GyuUTDAnW3k+jNL0='
WHERE
key_id = 'ae3e8036296f2fbccae8ee46831b41974f2b97f6800bb26a29a8830f1907fa25'
AND (
token = 'k94eg5NJmEWIsmvI3Fh1uIowTG2GyuUTDAnW3k+jNL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)