UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4047wPq4eYU5t3jdkgcMkMgTJj5e2EmevnF4zNwENwM='
WHERE
key_id = 'a666e08cb9fce2be0ef415589b18d09afbab97b8684f73c1f80fde86ebda8178'
AND (
token = '4047wPq4eYU5t3jdkgcMkMgTJj5e2EmevnF4zNwENwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)