UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E0459+9taWNFBc6VYNwaxrdLF4Qws3cnmydjcrBDF+g='
WHERE
key_id = 'd09f1e3cc317ee559371a4977e1ec92d24a304fc6b507f671feabc8fbbd68bb2'
AND (
token = 'E0459+9taWNFBc6VYNwaxrdLF4Qws3cnmydjcrBDF+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)