UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'new+nI5WZRv6vKCOfor/E7Yqh2qQJFnRvZdJqym4Gns='
WHERE
key_id = '4c44545d825a66c9654660647e4f5b6687a273df3ce4812d8c73b44250e34149'
AND (
token = 'new+nI5WZRv6vKCOfor/E7Yqh2qQJFnRvZdJqym4Gns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)