UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qp9Suip9OL8cTgI6lvFAB1CS8OSuugVn/ofc5qb+EPw='
WHERE
key_id = 'c38ace768bd7009e5c8d211069dde6bf736d19d8069bf64148332d12e1156fbd'
AND (
token = 'Qp9Suip9OL8cTgI6lvFAB1CS8OSuugVn/ofc5qb+EPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)