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