UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8VFvaDdWykXe/M0xpX74L6PREh8JJ3CvvX2SW0c6px0='
WHERE
key_id = '831ac670877cd4d4f226c67574843ba36884cd14b8e7f9b0f28501eb9d1ab210'
AND (
token = '8VFvaDdWykXe/M0xpX74L6PREh8JJ3CvvX2SW0c6px0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)