UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VKNvlrpAqaEPt9W3VulvWSSWKI8jqWCgjoRb+lCLdAI='
WHERE
key_id = 'c20d559f0ba777f015c3ad532ed84bd8cd4b00db0aa5c879c3ed4b71a6e8f517'
AND (
token = 'VKNvlrpAqaEPt9W3VulvWSSWKI8jqWCgjoRb+lCLdAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)