UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'loR46lC1nttqa4XW+pMAHoKkE/SRKxkcxEJMzXKpaNQ='
WHERE
key_id = '55cd8520eeee86dabc177cc7da526f38f874eaf94385bd6a2967886a7dbe5469'
AND (
token = 'loR46lC1nttqa4XW+pMAHoKkE/SRKxkcxEJMzXKpaNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)