UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6YCTl/J5dREMN1ap8a359LLDqqrXsWhE5vd2/9ZZ9us='
WHERE
key_id = '4ca9f328b7bf38259d4d475b772ff02f1691c868422706c6d8c186bbca105aca'
AND (
token = '6YCTl/J5dREMN1ap8a359LLDqqrXsWhE5vd2/9ZZ9us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)