UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cn1Zc5+XYusCoHe2FsV5iPlNymE5v6tfgMOhgn77gv0='
WHERE
key_id = '5fcb19179747278296c4c6d5e75f79e009e0647490602a76c8e76c89515cf4fb'
AND (
token = 'Cn1Zc5+XYusCoHe2FsV5iPlNymE5v6tfgMOhgn77gv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)