UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0upeT08642qk9PUgbnJJS9b6g6Hkkd1+hE1LeHWWYlA='
WHERE
key_id = '12bf301432c0087a34e4eb306efce8091f97830a227fe4f115794af5f867f28e'
AND (
token = '0upeT08642qk9PUgbnJJS9b6g6Hkkd1+hE1LeHWWYlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)