UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4wxA2GFQ6rU0bLMq/SJPQUIKvgWRh4hlv2UpsOwZWRo='
WHERE
key_id = '6f5867a430b0579c1eac5d338651bcd1a0199d1304d8506716c8729be67df264'
AND (
token = '4wxA2GFQ6rU0bLMq/SJPQUIKvgWRh4hlv2UpsOwZWRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)