UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kQDxhgXhy+l41kRW2xRPVJhEDQgUVZvzZ2i54j6891w='
WHERE
key_id = 'ecb1627d1b159c5d3a23fd8c678b3b68b2ce09f421046ad930e4a8943572750b'
AND (
token = 'kQDxhgXhy+l41kRW2xRPVJhEDQgUVZvzZ2i54j6891w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)