UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ei2OV8fz42mAmIeyPLOgthw4PlSu1OR2mnZbsMbCYw='
WHERE
key_id = '231d4ddcfc1bc24adae1b68eb592f980b0aa6b2d3b63965dd543f1528e9c4bf5'
AND (
token = '9ei2OV8fz42mAmIeyPLOgthw4PlSu1OR2mnZbsMbCYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)