UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MgPYRgt8PzuOu3xmx10kfbERodCnZIrkcMjqtxDfQjs='
WHERE
key_id = '482c7c37e6e956f52d9c508369e2b6cacc68ad544fd8e377709c622a0e197ce4'
AND (
token = 'MgPYRgt8PzuOu3xmx10kfbERodCnZIrkcMjqtxDfQjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)