UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4k6IzPifKh/6jI3Yakg4MhXqlxcjKzFBVbGhsTIrHqE='
WHERE
key_id = 'ec346ef7babed625e3c01ba143ecaa84460b07aa14a186ca970776e379b794e0'
AND (
token = '4k6IzPifKh/6jI3Yakg4MhXqlxcjKzFBVbGhsTIrHqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)