UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1aW7MVHmZWn/QxJOCFDmsYsBLXcuHunLACazjsSs3/g='
WHERE
key_id = '8344828310498aa602f062a16f7a30d3942f5e32b7bbc54b9c2b2e96f6a5b36a'
AND (
token = '1aW7MVHmZWn/QxJOCFDmsYsBLXcuHunLACazjsSs3/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)