UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PEB+FqZWM56w78kvW9hksiIHRnHseNzyBohKrC7y4yw='
WHERE
key_id = '0b03478150cb07fda53b054adba31c914b87343f20598932f615ee7d25c03605'
AND (
token = 'PEB+FqZWM56w78kvW9hksiIHRnHseNzyBohKrC7y4yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)