UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNSdxRTZ2zGr6ZGXOfA+tHU+sqXyB7wasnCJ9FG2OGs='
WHERE
key_id = 'a218e1eed907d0f37c051a9e516fe48baeca592f009de7d1bbd2551d9e596820'
AND (
token = 'KNSdxRTZ2zGr6ZGXOfA+tHU+sqXyB7wasnCJ9FG2OGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)