UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PeGU8fYpWsunjMG2xQC7KgWbME06uMksTr/NW3Yy1K8='
WHERE
key_id = '1a8f92adc38241c46c40e5b64a6f8ac08dafcd985cd8ab7d3949ae44198c5297'
AND (
token = 'PeGU8fYpWsunjMG2xQC7KgWbME06uMksTr/NW3Yy1K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)