UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNRDpxlijHkAgz5pj8gcI0U7U9eUETE8RYSRPa1zHe4='
WHERE
key_id = 'aaf0e693e95e9702bec2d37ac08bafb7399253eb60051f95c883c55ab3a4eff9'
AND (
token = 'QNRDpxlijHkAgz5pj8gcI0U7U9eUETE8RYSRPa1zHe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)